﻿<%@ Page Title="WDPA: Advanced Search" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="MultiSelect.aspx.cs" Inherits="Default2" %>

<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" Runat="Server">
  <%--<asp:ScriptManager ID="ScriptManagerMaster" runat="server">        
    </asp:ScriptManager>--%>
  
  <div id="overDiv" style="position: absolute; visibility: hide; z-index: 1;">
    </div>

    <script language="JavaScript" src="script/overlib.js"></script>

   <div class=" PageTitle title"><img src="img/iconSearch.jpg" class="moduleIcon" /><h2>Advanced Marine Protected Area Search</h2>
    </div>
<br />
    
    <%--<asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>--%>
            <fieldset runat="server" id="FSSearchType">
                <legend style="color: #192F6B; font-weight: bold;">Search Type</legend>
                <br />
                <table width="100%" cellpadding="5" cellspacing="0" border="0">
                    <tr>
                        <td align="left" valign="top" style="padding: 5px;">
                            <%--<asp:UpdatePanel ID="UpdatePanel3" runat="server">--%>
                                <ContentTemplate>
                                    <asp:RadioButton ID="RBNatSearch" Checked="true" GroupName="SearchSelect" Text="National"
                                        runat="server" AutoPostBack="true" OnCheckedChanged="RBNatSearch_CheckedChanged" />&nbsp;
                                    <asp:RadioButton ID="RBIntSearch" GroupName="SearchSelect" Text="International" runat="server"
                                        AutoPostBack="true" OnCheckedChanged="RBIntSearch_CheckedChanged" />&nbsp;
                                    <%-- <asp:RadioButton ID="RBAll" GroupName="SearchSelect" Text="All" runat="server" AutoPostBack="true"
                                        Checked="true" OnCheckedChanged="RBAll_CheckedChanged" />--%>
                                </ContentTemplate>
                           <%-- </asp:UpdatePanel>--%>
                        </td>
                        <td align="left" valign="top" style="padding: 5px;">
                            <div id="LoadingImage1">
                               <%-- <asp:UpdateProgress ID="UpdateProgress2" AssociatedUpdatePanelID="UpdatePanel3" DynamicLayout="true"
                                    runat="server">
                                    <ProgressTemplate>
                                        <p style="font-size: 10px; vertical-align: middle; color: #192F6B;">
                                            <img src="Images/MultiSelect/designation-load.gif" alt="Loading..." />&nbsp;&nbsp;Refining
                                            Search Options.....</p>
                                    </ProgressTemplate>
                                </asp:UpdateProgress>--%>
                            </div>
                        </td>
                    </tr>
                </table>
                <br />
            </fieldset>
            <br />
            <fieldset runat="server" id="FSGeneral">
                <legend style="color: #192F6B; font-weight: bold;">General Search Options</legend>
                <br />
                <table width="100%" cellpadding="5" cellspacing="0" border="0">
                    <tr>
                        <td align="left" valign="top" style="padding: 5px; width: 75%;">
                           <%-- <asp:UpdatePanel ID="UpdatePanel2" runat="server">--%>
                                <ContentTemplate>
                                    <asp:DropDownList ID="Country" AppendDataBoundItems="true" runat="server" DataSourceID="SqlDataSource4"
                                        DataTextField="ShortName" DataValueField="ID" AutoPostBack="True" OnSelectedIndexChanged="Country_SelectedIndexChanged"
                                        Width="335px">
                                        <asp:ListItem Text="Country/Territory..." Value=""></asp:ListItem>
                                    </asp:DropDownList>
                                    <asp:RequiredFieldValidator ID="RequiredFieldValidator1" InitialValue="" runat="server"
                                        ToolTip="Please Choose a Country from the list" ErrorMessage="Required." ControlToValidate="Country">* Required</asp:RequiredFieldValidator><br />
                                    <p>
                                        Please see <a href="FAQ.aspx">FAQ's</a> regarding protected areas in the United
                                        Kingdom</p>
                                </ContentTemplate>
                           <%-- </asp:UpdatePanel>--%>
                            <div id="LoadingImage2">
<%--                                <asp:UpdateProgress ID="UpdateProgress1" AssociatedUpdatePanelID="UpdatePanel2" DynamicLayout="true"
                                    runat="server">
                                    <ProgressTemplate>
                                        <p style="font-size: 10px; vertical-align: middle; color: #192F6B;">
                                            <img src="Images/MultiSelect/designation-load.gif" alt="Loading..." />&nbsp;Refining
                                            Search Options.....</p>
                                    </ProgressTemplate>
                                </asp:UpdateProgress>--%>
                            </div>
                        </td>
                        <td align="right" valign="top" style="padding: 5px; width: 25%;">
                            <table width="100%" cellpadding="0" cellspacing="0" border="0">
                                <tr>
                                    <td align="left">
                                        <asp:RadioButton ID="RBMPAAll" Checked="true" GroupName="MPASelect" Text="All" runat="server"
                                            AutoPostBack="true" OnCheckedChanged="RBMPASelect_CheckedChanged" />&nbsp;<img runat="server"
                                                id="WDPAHelpAll" src="img/helpQM.jpg" onmouseover="drc('All Sites','Definition of &quot;All&quot;'); return true;"
                                                onmouseout="nd(); return true;" style="border: none;" border="0" height="15"
                                                width="15" visible="false" /><img runat="server" id="WDPAMarineHelpAll" src="img/helpQM.jpg" onmouseover="drc('Includes all Marine, Marine and Terrestrial Protected Areas.','Definition of &quot;All&quot;'); return true;"
                                                    onmouseout="nd(); return true;" style="border: none;" border="0" height="15"
                                                    width="15" visible="false" />
                                        <br />
                                        <asp:RadioButton ID="RBMPAMarine" GroupName="MPASelect" Text="Marine" runat="server"
                                            AutoPostBack="true" OnCheckedChanged="RBMPASelect_CheckedChanged" />&nbsp;<img runat="server"
                                                id="WDPAHelpMarine" src="img/helpQM.jpg" onmouseover="drc('Descriptive text goes here.','Definition of &quot;Marine&quot;'); return true;"
                                                onmouseout="nd(); return true;" style="border: none;" border="0" height="15"
                                                width="15" visible="false" /><img runat="server" id="WDPAMarineHelpMarine" src="img/helpQM.jpg" onmouseover="drc('Includes Marine Protected Areas.','Definition of &quot;Marine Only&quot;'); return true;"
                                                    onmouseout="nd(); return true;" style="border: none;" border="0" height="15"
                                                    width="15" visible="false" />
                                        <br />
                                        <asp:RadioButton ID="RBMPATerrestrialCoastal" GroupName="MPASelect" Text="Terrestrial"
                                            runat="server" AutoPostBack="true" OnCheckedChanged="RBMPASelect_CheckedChanged" />&nbsp;<img
                                                runat="server" id="WDPAHelpTerrestrial" src="img/helpQM.jpg" onmouseover="drc('Descriptive text goes here.','Definition of &quot;Terrestrial&quot;'); return true;"
                                                onmouseout="nd(); return true;" style="border: none;" border="0" height="15"
                                                width="15" visible="false" /><img runat="server" id="WDPAMarineHelpTerrestrial" src="img/helpQM.jpg"
                                                    onmouseover="drc('Includes Terrestrial Protected Areas indicated as having a Marine element.','Definition of &quot;Marine &amp; Terrestrial&quot;'); return true;"
                                                    onmouseout="nd(); return true;" style="border: none;" border="0" height="15"
                                                    width="15" visible="false" />
                                    </td>
                                </tr>
                            </table>
                        </td>
                        <%-- <td align="right" style="padding:5px;">
     <asp:Label ID="LMPA" runat="server" Font-Bold="true" Text="MPA:"></asp:Label><br />
	 <asp:ListBox ID="MPA" Width="425px" AppendDataBoundItems="true" runat="server" AutoPostBack="true" DataSourceID="SqlDataSource6" DataTextField="Type" DataValueField="ID" OnChange="GetMultipleMPAID()" SelectionMode="Multiple">
	 <asp:ListItem Selected="True" Text="All" Value=""></asp:ListItem>
	 </asp:ListBox>
	 </td>--%>
                    </tr>
                </table>
                <div runat="server" id="divGenMarine" visible="false">
                    <table width="100%" cellpadding="5" cellspacing="0" border="0">
                        <tr>
                            <td style="width: 60%;">
                                <asp:DropDownList ID="DDLDocTotalMarineArea" runat="server" AutoPostBack="true" Width="335px">
                                    <asp:ListItem Value="" Text="Documented Total Marine Area..."></asp:ListItem>
                                    <asp:ListItem Value="0" Text="< 1,000 (ha)"></asp:ListItem>
                                    <asp:ListItem Value="1" Text="1,000,000 - 5,000 (ha)"></asp:ListItem>
                                    <asp:ListItem Value="2" Text="5,000 - 10,000 (ha)"></asp:ListItem>
                                    <asp:ListItem Value="3" Text="10,000 - 25,000 (ha)"></asp:ListItem>
                                    <asp:ListItem Value="4" Text="25,000 - 50,000 (ha)"></asp:ListItem>
                                    <asp:ListItem Value="5" Text="50,000 - 100,000 (ha)"></asp:ListItem>
                                    <asp:ListItem Value="6" Text="100,000 - 500,000 (ha)"></asp:ListItem>
                                    <asp:ListItem Value="7" Text="500,000 - 1,000,000 (ha)"></asp:ListItem>
                                    <asp:ListItem Value="8" Text="> 1,000,000 (ha)"></asp:ListItem>
                                </asp:DropDownList>
                            </td>
                            <td style="width: 40%;">
                                <%--<asp:DropDownList ID="DDLGISTotalMarineArea" runat="server" Width="335px" AutoPostBack="true">
                                    <asp:ListItem Value="" Text="GIS Total Marine Area..."></asp:ListItem>
                                </asp:DropDownList>--%>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                <asp:DropDownList ID="DDLNoTakeReg" runat="server" Width="335px" AutoPostBack="True"
                                    DataSourceID="SqlDataSource5" DataTextField="NotakeEnt" AppendDataBoundItems="true"
                                    DataValueField="Code">
                                    <asp:ListItem Value="" Text="No Take Regulation..."></asp:ListItem>
                                </asp:DropDownList>
                            </td>
                            <td>
                                <fieldset runat="server" id="FSMarineComponent">
                                    <legend style="color: #192F6B;">Marine Component</legend>
                                    <table width="100%" cellpadding="5" cellspacing="0" border="0">
                                        <tr>
                                            <td>
                                                <asp:CheckBox ID="CBSubtidal" AutoPostBack="true" runat="server" />&nbsp;Subtidal&nbsp;<img runat="server"
                                                id="WDPASubtidal" src="img/helpQM.jpg" onmouseover="drc('Subtidal','Definition of &quot;Subtidal&quot;'); return true;"
                                                onmouseout="nd(); return true;" style="border: none;" border="0" height="15"
                                                width="15" />
                                            </td>
                                            <td>
                                                <asp:CheckBox ID="CBIntertidal" AutoPostBack="true" runat="server" />&nbsp;Intertidal&nbsp;<img runat="server"
                                                id="WdpaIntertidal" src="img/helpQM.jpg" onmouseover="drc('Intertidal','Definition of &quot;Intertidal&quot;'); return true;"
                                                onmouseout="nd(); return true;" style="border: none;" border="0" height="15"
                                                width="15" />
                                            </td>
                                        </tr>
                                    </table>
                                </fieldset>
                            </td>
                        </tr>
                    </table>
                </div>
                <br />
            </fieldset>
            <br />
            <fieldset runat="server" id="FSNational">
                <legend style="color: #192F6B; font-weight: bold;">National Search Options</legend>
                <br />
                <table width="100%" cellpadding="5" cellspacing="0" border="0">
                    <tr>
                        <td align="left" valign="top" style="padding: 5px;">
                            <asp:Label Font-Bold="true" ID="LDesignation" runat="server" Text="Designation:"></asp:Label>
                            <br />
                            <asp:ListBox ID="Designation" AppendDataBoundItems="true" AutoPostBack="false" OnChange="GetMultipleDesignationID(); return false;"
                                runat="server" DataSourceID="SqlDataSource2" DataTextField="WCMCDescription"
                                DataValueField="ID" SelectionMode="Multiple" Width="335px">
                                <asp:ListItem Selected="True" Text="All" Value=""></asp:ListItem>
                            </asp:ListBox>
                        </td>
                        <td align="right" valign="top" style="padding: 5px;">
                            <asp:Label Font-Bold="true" ID="LIUCN" runat="server" Text="IUCN Category:"></asp:Label><br />
                            <asp:ListBox ID="IUCNCategory" AppendDataBoundItems="true" AutoPostBack="false" OnChange="GetMultipleIUCNCatID(); return false;"
                                runat="server" DataSourceID="SqlDataSource1" DataTextField="IUCNCategory" DataValueField="IUCNCategory"
                                SelectionMode="Multiple" Width="335px">
                                <asp:ListItem Selected="True" Text="All" Value=""></asp:ListItem>
                            </asp:ListBox>
                        </td>
                    </tr>
                </table>
                <br />
            </fieldset>
            <div id="AllSpacer" runat="server">
                <br />
            </div>
            <fieldset runat="server" id="FSInternational">
                <legend style="color: #192F6B; font-weight: bold;">International Search Options</legend>
                <br />
                <table width="100%" cellpadding="0" cellspacing="0" border="0">
                    <tr>
                        <td align="left" valign="top" style="padding: 5px;">
                            <asp:Label Font-Bold="true" ID="LConvention" runat="server" Text="Convention:"></asp:Label><br />
                            <asp:ListBox ID="Convention" onScroll="SetValue(); return false;" AppendDataBoundItems="true"
                                AutoPostBack="true" OnChange="GetMultipleConventionID()" runat="server" DataSourceID="SqlDataSource3"
                                DataTextField="Name" DataValueField="ID" SelectionMode="Multiple" Width="335px"
                                OnSelectedIndexChanged="Convention_SelectedIndexChanged">
                                <asp:ListItem Selected="True" Text="All" Value=""></asp:ListItem>
                            </asp:ListBox>
                            <asp:HiddenField ID="HideValue" runat="server" Value="0" />
                        </td>
                        <td align="right" valign="top" style="padding: 5px;">
                            <%-- <asp:Label Font-Bold="true" ID="LCriteria" runat="server" Text="Criteria:"></asp:Label><br />
                            <asp:ListBox ID="Criteria" AutoPostBack="false" AppendDataBoundItems="true" runat="server"
                                DataSourceID="SqlDataSource5" DataTextField="Description" DataValueField="ID"
                                SelectionMode="Multiple" Width="335px" onChange="GetMultipleCriteriaID();">
                                <asp:ListItem Selected="True" Text="All" Value=""></asp:ListItem>
                            </asp:ListBox>--%>
                            &nbsp;
                        </td>
                    </tr>
                </table>
                <br />
            </fieldset>
            <%--<asp:UpdatePanel ID="UpdatePanelSearch" runat="server">
                <ContentTemplate>--%>
                    <table width="100%" cellpadding="5" cellspacing="0" border="0">
                        <tr>
                            <td style="padding: 5px; text-align: right;">
                                <asp:Button ID="btnSearch" runat="server" Text="Search" OnClick="btnSearch_Click" />
                            </td>
                        </tr>
                    </table>
               <%-- </ContentTemplate>
            </asp:UpdatePanel>--%>
            <table width="100%" cellpadding="0" cellspacing="0" border="0">
                <tr>
                    <td style="text-align: center;">
                        <div id="LoadingImage3">
                       <%--     <asp:UpdateProgress ID="UpdateProgress3" AssociatedUpdatePanelID="UpdatePanelSearch"
                                DynamicLayout="true" runat="server">
                                <ProgressTemplate>
                                    <p style="font-size: 10px; vertical-align: middle; color: #192F6B;">
                                        <img src="Images/MultiSelect/multiselect-searchprogress.gif" alt="Searching..." /><br />
                                        &nbsp;&nbsp;&nbsp;&nbsp;<em>Searching.....</em></p>
                                </ProgressTemplate>
                            </asp:UpdateProgress>--%>
                        </div>
                    </td>
                </tr>
            </table>
            <div id="divIDControls" runat="server" style="display: none;">
                <%--<asp:TextBox ID="tbMPA" runat="server"></asp:TextBox>--%>
                <asp:TextBox ID="tbDesignation" runat="server"></asp:TextBox>
                <asp:TextBox ID="tbIUCNCategory" runat="server"></asp:TextBox>
                <asp:TextBox ID="tbConvention" runat="server"></asp:TextBox>
                <%--<asp:TextBox ID="tbCriteria" runat="server"></asp:TextBox>--%>
            </div>
        </ContentTemplate>
   <%-- </asp:UpdatePanel>--%>


<script language="javascript" type="text/javascript">
function GetMultipleDesignationID()
{
var intext ;
var first = "";


intext = "";

for (var idx = document.getElementById("<%=Designation.ClientID%>").options.length - 1; idx >= 0; idx--)
 {
    if (document.getElementById("<%=Designation.ClientID%>").options[idx].selected == true)
     {
        intext = intext + first + document.getElementById("<%=Designation.ClientID%>").options[idx].value;
           
        if (first == "")
        {
         first = ", "
        }
     }
 }
 document.getElementById("<%=tbDesignation.ClientID%>").value = intext;
}

function GetMultipleIUCNCatID()
{
var intext ;
var first = "";
var first2 = "";


intext = "";

for (var idx = document.getElementById("<%=IUCNCategory.ClientID%>").options.length - 1; idx >= 0; idx--)
 {
    if (document.getElementById("<%=IUCNCategory.ClientID%>").options[idx].selected == true)
     {
        intext = intext + first + first2 + document.getElementById("<%=IUCNCategory.ClientID%>").options[idx].value;
           
        if (first == "")
        {
         first = "', "
        }
        
        if (first2 == "")
        {
        first2 = "'"
        }
     }
 }
 document.getElementById("<%=tbIUCNCategory.ClientID%>").value = "'" + intext + "'";
}

function GetMultipleConventionID()
{
var intext ;
var first = "";


intext = "";

for (var idx = document.getElementById("<%=Convention.ClientID%>").options.length - 1; idx >= 0; idx--)
 {
    if (document.getElementById("<%=Convention.ClientID%>").options[idx].selected == true)
     {
        intext = intext + first + document.getElementById("<%=Convention.ClientID%>").options[idx].value;
           
        if (first == "")
        {
         first = ", "
        }
     }
 }
 document.getElementById("<%=tbConvention.ClientID%>").value = intext;
}
    </script>

    <script type="text/javascript">
                var prm = Sys.WebForms.PageRequestManager.getInstance();
                prm.add_pageLoaded(pageLoaded);

                function pageLoaded(sender, args) 
                 {
                    LoadValue()
                 }
                 function LoadValue()
                 {
                 document.getElementById("<%=Convention.ClientID%>").scrollTop=document.getElementById("<%=HideValue.ClientID%>").value;
                 }
                 function SetValue()
                 {
                 var value=document.getElementById("<%=Convention.ClientID%>").scrollTop;  
                 document.getElementById("<%=HideValue.ClientID%>").value=value;
                 }
               
    </script>



    <!-- DataSources -->
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:WDPAConnectionString1 %>"
        SelectCommand="SELECT DISTINCT IUCNCategory, CASE WHEN IUCNCategory = 'Not known' THEN 2 ELSE 1 END AS OrderSequence
FROM         WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPA 
WHERE     (IUCNCategory &lt;&gt; 'Not Applicable ') AND (IUCNCategory &lt;&gt; '-1') AND (IUCNCategory &lt;&gt; '-999')
UNION
SELECT DISTINCT IUCNCategory, CASE WHEN IUCNCategory = 'Not known' THEN 2 ELSE 1 END AS OrderSequence
FROM         WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPApt 
WHERE     (IUCNCategory &lt;&gt; 'Not Applicable ') AND (IUCNCategory &lt;&gt; '-1') AND (IUCNCategory &lt;&gt; '-999')
ORDER BY OrderSequence, IUCNCategory"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:WDPAConnectionString1 %>"
        SelectCommand="SELECT DISTINCT Designation.ID, Designation.WCMCDescription
                      FROM Designation INNER JOIN
                      WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPA ON Designation.ID = WDPAmarineForEc2.                       wdpa_admin.CurrentSiteWDPA.English_Designation
                      WHERE (Designation.WCMCDescription &lt;&gt; 'Not Applicable')
                      UNION
                        SELECT DISTINCT Designation_1.ID, Designation_1.WCMCDescription
                        FROM Designation AS Designation_1 INNER JOIN
                      WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPApt ON Designation_1.ID =                                      WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPApt.English_Designation
                      WHERE (Designation_1.WCMCDescription &lt;&gt; 'Not Applicable')
                        ORDER BY Designation.WCMCDescription"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:WDPAConnectionString1 %>"
        SelectCommand="SELECT DISTINCT IRConventionEntity.ID, IRConventionEntity.NAME
FROM         IRConventionEntity INNER JOIN
                      WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPA ON IRConventionEntity.ID = 

WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPA.International_Convention
WHERE IRConventionEntity.NAME &lt;&gt; 'Not Applicable' 
UNION
SELECT DISTINCT IRConventionEntity_1.ID, IRConventionEntity_1.NAME
FROM         IRConventionEntity AS IRConventionEntity_1 INNER JOIN
                      WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPApt ON IRConventionEntity_1.ID =    
WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPApt.International_Convention
WHERE IRConventionEntity_1.NAME &lt;&gt; 'Not Applicable'
ORDER BY IRConventionEntity.NAME"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:WDPAConnectionString1 %>"
        SelectCommand="SELECT DISTINCT Country.ID, Country.ShortName
FROM         Country INNER JOIN
                      WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPA ON Country.ID = WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPA.Country
                      WHERE (Country.ID &lt;&gt; '77') 
UNION
SELECT DISTINCT Country_1.ID, Country_1.ShortName
FROM         Country AS Country_1 INNER JOIN
                      WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPApt ON Country_1.ID = WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPApt.Country
                       WHERE (Country_1.ID &lt;&gt; '77') 
ORDER BY Country.ShortName"></asp:SqlDataSource>
    <%--<asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:WDPAConnectionString1 %>"
        SelectCommand="SELECT DISTINCT Criteria.ID, Criteria.Description
FROM         Criteria INNER JOIN
                      WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPA ON Criteria.ID = WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPA.Criteria
                      WHERE Criteria.Description &lt;&gt; 'Not Applicable' 
UNION
SELECT DISTINCT Criteria_1.ID, Criteria_1.Description
FROM         Criteria AS Criteria_1 INNER JOIN
                      WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPApt ON Criteria_1.ID = WDPAmarineForEc2.wdpa_admin.CurrentSiteWDPApt.Criteria
                      WHERE Criteria_1.Description &lt;&gt; 'Not Applicable' 
ORDER BY Criteria.Description"></asp:SqlDataSource>--%>
    <asp:SqlDataSource ID="SqlDataSource6" runat="server" ConnectionString="<%$ ConnectionStrings:WDPAConnectionString1 %>"
        SelectCommand="SELECT * FROM [MarineEntity] WHERE (ID != '-2')"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:WDPAConnectionString1 %>"
        SelectCommand="SELECT     Code, NotakeEnt
FROM         NoTakeEntity2
ORDER BY NotakeEnt"></asp:SqlDataSource>
    <!-- -->
</asp:Content>

